package com.gljx.web.service;

import com.gljx.web.Entity.SubjectOneResult;
import com.gljx.web.Entity.User;
import org.apache.poi.ss.usermodel.Workbook;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;
import java.util.Map;

public interface SubjectOneResultService {
	Map<String, Object> selectPageCount(String psql);

    Map<String, Object> selectPage(int pindex, String psql, int psize);
    
    /**
	 * 查找最大编码
	 * @return
	 */
	String selectFnumber(String companyId);
	/**
	 * 增加父类科目一考试结果登记信息
	 * @param subjectOneResult
	 * @return
	 */
	int addSubjectOneResult(SubjectOneResult subjectOneResult);
	/**
	 * 根据fid删除
	 * @param fid
	 * @return
	 */
	int deleteSubjectOneResult(String fid);
	/**
	 * 根据fid查找科目一考试结果登记信息
	 * @param fid
	 * @return
	 */
	SubjectOneResult selectSubjectOneResultByFid(String fid);
	
	/**
	 * 根据fid修改科目一考试结果登记信息
	 * @param fid
	 * @return
	 */
	int updateSubjectOneReusltByFid(SubjectOneResult subjectOneResult);
	
	/**
	 * 导入Excel到科目一考试结果登记
	 * @param workbook
	 * @param user
	 * @param request
	 */
	void importExcelSubjectOneResult(Workbook wb,User user,HttpServletRequest request);

	/**
	 * 科目一考试结果登记 导出excel
	 * @param companyId
	 * @param fnumber
	 * @param fdescription
	 * @param beginTime
	 * @param endTime
	 * @return
	 */
	List<SubjectOneResult> selectSubjectOneResult(String companyId,String fnumber,String fdescription,String beginTime,String endTime);


	/**
	 * 导出科目一成绩
	 * @param user
	 * @param request
	 */
	//void importExcelSubjectTowResult(Workbook wb,User user,HttpServletRequest request);
}
